Create Drill Through Pages 12
Create Drill throughs Pages
Create Member sign up Name Drill throughs
· · Open new page
Member sign up Name table
·
Date
·
Member Name (Members table)
·
Referral Name (Members table) After select Go to the
value and right click and change to count
Formatting
·
Style
-Bold header flashy
rows
·
Value
-Font color – white
-Background color – (#
836d52)
-Alternate font color –
white
-Alternate Background
color (#108372)
-Title – click FX and
choose - Field value
-
Member Page Title
Member
Signup All-Time Record
·
Member Name
·
Referrals Signup
·
. Total commission
·
AVG Time for 1st
Formatting
·
Style
-Bold header flashy
rows
·
Value
-Font color – white
-Background color – (#
836d52)
-Alternate font color –
white
-Alternate Background
color (#108372)
-Title – Member Sign-Up
All-Time Record
Create Member sign up Name Drill
throughs KPI’S
KPI 1
·
Select Card Visualization
· Drag and Drop ThisMth vs AVGMthlySignup
Formatting
·
Data the label put below formatting
KPI
2
·
Select Card Visualization
·
Drag and Drop Member Sign Up per Month
KPI
3
·
Select Card Visualization
·
Drag and Drop AVG Member Per Month
·
KPI
4
·
Select Card Visualization
· Drag and Drop AVG Time for 1st Reward
Create search Visual
·
Select the Text filter
·
Drag and Drop Member name on the field from member table
Referrals Enrollment Drill- through
· Open new page
Referrals Enrollment Table
·
Date
·
Referral Name
·
RFM_ Paid Tuition
·
RFM_ In Class 30days
·
Status
·
RFM_IPBC
·
RFM_JRP
·
RFM_ Placement
·
Post Job Payment
·
Post 10 days login
Formatting
·
Style
-Bold header flashy
rows
·
Value
-Font color – white
-Background color – (#
836d52)
-Alternate font
color – white
-Alternate Background
color (#108372)
-Title – click FX and
choose - Field value
- Referral Page Title
Create Referrals Enrollment Drill-
through KPI's
KPI 1
·
Select Card Visualization
·
Drag and Drop ThisMth vs AVGMthlyEnrollment
Formatting
·
Data
label put below formatting
KPI
2
·
Select Card Visualization
·
Drag and Drop Referral Enrollment per Month
KPI
3
·
Select Card Visualization
·
Drag and Drop AVG Enrolled Per Month
KPI
4
·
Select Card Visualization
·
Drag and Drop % Complete
Create search Visual
·
Select the Text filter
·
Drag and Drop Member name on the field from member table
Reward Payout Drill-Through
· Open new page
· Reward level 1
-
Commission 1 Reached (Commission 1 table)
-
Member Name (Commission 1 table)
-
First Reward (Calculated table)
Formatting
·
Style
-Bold header flashy
rows
·
Value
-Font color – white
-Background color – (#
836d52)
-Alternate font color –
white
-Alternate Background
color (#108372)
-Title – click FX and
choose - Field value
-
RL1 Page Title
· Reward level 2
-
Commission 2 Reached (Commission 2 table)
-
Member Name (Commission 2 table)
-
Second Reward (Calculated table)
Formatting
·
Style
-Bold header flashy
rows
·
Value
-Font color – white
-Background color – (#
836d52)
-Alternate font color –
white
-Alternate Background
color (#108372)
-Title – click FX and
choose - Field value
- RL2 Page Title
· Total Payout
-Choose Stacked bar chart
- Axis
-Date
- Values
-Total payout
Formatting
·
Y-Axis
-Categorical
·
Data Color -(#
836d52)
·
Data labels
-ON
·
Title – click FX and choose - Field value
- Total Payout Title
Create
Reward
Payout Drill-Through Kip’s
KPI 1
·
Select Card Visualization
· Drag and Drop ThisMth vs AVGMthlyPayout
Formatting
·
Data
label put below formatting
KPI
2
·
Select Card Visualization
·
Drag and Drop Referral Payout per Month
·
Rename the name to Payout per Month
KPI
3
·
Select Card Visualization
·
Drag and Drop Avg Payout Per Month
Create search Visual
·
Select the Text filter
·
Drag and Drop Member name on the field from member table
ROI Details Drill-through
·
Open new page
Create a Total Cost Element
-Choose Line and Stacked
bar chart
- Shared Axis -Date
- Column Values -Total payout
- Line Values - Program cost
Formatting
·
Y-Axis
-Categorical
·
Data Color
- Program
cost - (#b5411e)
- Default color
- (# 836d52)
-(# 836d52)
·
Data labels
-ON
·
Title – click FX and choose - Field value
- TCE ROI Page Title
Create
Tuition Visual
-Choose
Stacked bar chart
- Axis
-Date
- Values
-Total Tuition
Formatting
·
Y-Axis
-Categorical
·
Data Color
- Default
color - (# 836d52)
·
Data labels
-ON
·
Title – click FX and choose - Field value
- TT ROI Page Title
Create
ROI Details
-Choose
Tornado visual
- Group
-Date
- Values
-Total Tuition
- ROI per month
Formatting
·
Data Color
- Total Tuition - (# 836d52)
- ROI per month -(#b5411e)
·
Data labels
-ON
·
Title – click FX and choose - Field value
- ROI Page Title
Create ROI Details
Drill-through KPI's
KPI 1
·
Select Card Visualization
·
Drag and Drop ThisMth vs AVGMthlyROI
Formatting
·
Data
label put below formatting
KPI 2
·
Select Card Visualization
·
Drag and Drop ROI per Month
KPI 3
·
Select Card Visualization
·
Drag and Drop AVG ROI Per Month
below link help to create drill-through report in power bi
https://www.youtube.com/watch?v=q_o342K9JGA